 /*
{
"状态":1,
"名称":"根据款号获取需要下载的图片地址",
"作者":"谌舜谋",
"创建时间":"2018-10-13",
"功能":"根据款号获取需要下载的图片地址",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/

 declare @style_no varchar(100)
 declare @tmpUrl varchar(100)
 declare @hardwareinfo varchar(100)   --硬件信息
 set @style_no='{style_no}'
 set @hardwareinfo = '{hardwareinfo}'
 --set @style_no='K18303-60046-1,K18303-60046-2' 
 --set @hardwareinfo ='S27WNXAH202255BFEBFBFF000406E3'

 if object_id('tempdb..#t_style')<>0
 drop table #t_style
select * into #t_style from Ft_Split(@style_no,',')
  
 select ad_img_key as img_key,style_no,url as oss_url,img_path,angle from ad_imgs a
	 inner join #t_style b on a.style_no=b.[value]
	 inner join b_ad_screen c on a.url ='http://ei-uploader.oss-cn-hangzhou.aliyuncs.com/img/style/'+style_no+img_path
	where hardwareinfo=@hardwareinfo
	 


  